<#assign leftSharp="<"/>
${leftSharp}?xml version="1.0" encoding="UTF-8"?>
${leftSharp}!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

${leftSharp}mapper namespace="${geneGlobalConfig.basePackage}.mapper.${geneTable.tableName}Mapper">

    ${leftSharp}sql id="baseSqlId">
    <#list geneTable.columns as column>
        ${column.columnName}<#if column_has_next>,</#if>
    </#list>
    ${leftSharp}/sql>

    ${leftSharp}sql id="camelSqlId">
    <#list geneTable.columns as column>
        <#if column.columnName == column.columnNameCamel>${column.columnName}<#if column_has_next>,</#if>
<#else >${column.columnName} AS ${column.columnNameCamel}<#if column_has_next>,</#if>
        </#if>
    </#list>
    ${leftSharp}/sql>
${leftSharp}/mapper>
